﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using QLTH_DTO;
namespace QLTH_DATASSECC
{
  public   class clsPhanLoaiDA: ConnectionData.clsKetNoi
    {
      String _sql;
      public DataTable DSPhanLoai()
      {
          _sql = "select * from PHANLOAIHS; ";
          return Load_DataTable(_sql);
      }

      public string Layma_PL(String _dk)
       {
           _sql = "SELECT MAPL FROM PHANLOAIHS WHERE TENPL = N'"+_dk+"'";
           return laymadk(_sql).ToString();
       }
    }
}
